/***********************************************************************************************************************************
 * Name:	RowNotFound.sql
 * Author:	Frank Figearo (frank.figearo@us.bbaaviation.com|frank@sqlnerd.me)
 * Summary:	Find out where the missing row was.
 */
SET IMPLICIT_TRANSACTIONS OFF; IF 0 < @@TRANCOUNT ROLLBACK;
USE DistributionDB;
GO

-- (Transaction sequence number: 0x000097EF00000113004D00000000, Command ID: 20)
DECLARE
  @xact_varbinary	VARBINARY(16)	=  0x000097EF00000113004D00000000,
  @xact_nchar		NCHAR(22)		= '0x000097EF00000113004D00000000',
  @command_id		INT				= 20;

SELECT *
  FROM dbo.MSarticles
  WHERE article_id IN (SELECT article_id FROM MSrepl_commands WHERE xact_seqno = @xact_varbinary);

EXECUTE sys.sp_browsereplcmds @xact_seqno_start= @xact_nchar, @xact_seqno_end= @xact_nchar;

GO